package com.ysd.zytj.dao;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.ysd.zytj.model.Statistics;
import com.ysd.zytj.vo.StatisticsVO;

public interface IStatisticsDao extends JpaRepository<Statistics, Integer>{

	@Query(value="select MONTH,sum(num) num from statistics where year =:year GROUP BY MONTH",nativeQuery = true)
	List<Object> findMonth(String year);
}
